# -*- coding: utf-8 -*-  
import pandas as pd
from sqlalchemy import create_engine
import sqlalchemy as sa
import pyodbc

#url = "{}+pyodbc://{}:{}@{}:1433/{}".format('mssql', 'sa', 'P@ssword', '10.1.9.55', 'JobsDB_HK')
url = "mysql+pymysql://{}:{}@{}/{}".format('root', '@wxcrm2pwd#', '202.170.139.203', 'wxcrm')
engine = create_engine(url, encoding='utf8', echo=True)
#print(engine.table_names())

df = pd.read_sql(sa.text('SELECT * FROM coupon where Id>:Id'), engine, params={'Id': '10'})
print(df)